package com.wing.cabinet.controller.admin;

import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.bean.copier.CopyOptions;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.wing.cabinet.model.entity.Cabinet;
import com.wing.cabinet.model.entity.CellInventorySpace;
import com.wing.cabinet.model.request.CellInventorySpaceForm;
import com.wing.cabinet.model.response.CellInventoryProductVO;
import com.wing.cabinet.model.response.CellInventorySpaceVO;
import com.wing.cabinet.model.response.StorageInventorySpaceVO;
import com.wing.cabinet.service.CellInventorySpaceService;
import com.wing.cabinet.service.StorageInventorySpaceService;
import com.wing.cabinet.utils.ExcelUtils;
import com.wing.common.utils.JsonResult;
import com.wing.common.utils.PageResult;
import com.wing.web.annotation.RequestObjectFieldIgnore;
import com.wing.web.utils.JwtUtils;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import lombok.RequiredArgsConstructor;
import org.apache.commons.lang.StringUtils;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 *
 * @author
 */
@Validated
@Api(value = "Admin-售刀柜产品货道库存管理", tags = "#/cabinet/cellInventorySpace")
@RestController("cellInventorySpaceController")
@RequestMapping("cabinet/admin/cellInventorySpace")
@RequiredArgsConstructor
public class CellInventorySpaceController {

    private final CellInventorySpaceService cellInventorySpaceService;
    private final StorageInventorySpaceService storageInventorySpaceService;

    @ApiOperation(value = "查询所有售刀柜产品货道库存", notes = "搜索")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "page", value = "第几页", defaultValue = "1", example = "1", dataType = "Integer", paramType = "query")
            ,@ApiImplicitParam(name = "limit", value = "每页多少条", defaultValue = "10", example = "10", dataType = "Integer", paramType = "query")
            ,@ApiImplicitParam(name = "sort", value="排序字段名", defaultValue = "create_time", example = "create_time", dataType = "String", paramType = "query")
            ,@ApiImplicitParam(name = "order", value="排序规则(asc:正序, desc:倒序)", defaultValue = "asc", example = "asc", dataType = "String", paramType = "query")
    })
    @GetMapping("/list")
    public PageResult<CellInventorySpaceVO> list(
            @RequestParam(defaultValue = "1") Integer page
            , @RequestParam(defaultValue = "10") Integer limit
            , @RequestParam(defaultValue = "create_time") String sort
            , @RequestParam(defaultValue = "asc") String order
            , String code
            , String cabCode
            , String skuCode
            , String skuCode4Detail
            , String spaceCode
            , String mainCabCode
            , String queryFlag
            , Cabinet.CabinetNature cabinetNature
            ,String oldSpecCode
            ,String belongCabinet
            ,String query
            ){

        Page<CellInventorySpace> pg = new Page<>(page, limit);
        Map queryParam=new HashMap();
        queryParam.put("sort",StrUtil.toUnderlineCase(sort));
        queryParam.put("order",order);
        queryParam.put("code",code);
        queryParam.put("cabCode",cabCode);
        queryParam.put("skuCode",skuCode);
        queryParam.put("skuCode4Detail",skuCode4Detail);
        queryParam.put("spaceCode",spaceCode);
        queryParam.put("mainCabCode",mainCabCode);
        queryParam.put("queryFlag",queryFlag);
        queryParam.put("belongCabinet", belongCabinet);
        queryParam.put("enterpriseCode", JwtUtils.getEnterpriseCode());
        if (cabinetNature!=null){
            queryParam.put("cabinetNature",cabinetNature.getValue());
        }
        queryParam.put("oldSpecCode",oldSpecCode);
        if (StringUtils.isNotBlank(query)){
            queryParam.put("query",query);
        }
        //搜索

        IPage<CellInventorySpaceVO> list = cellInventorySpaceService.pageList(pg,queryParam);
        return new PageResult<>(list.getRecords(), list.getTotal());
    }


    @ApiOperation(value = "查询所有售刀柜产品货道库存(含告警)", notes = "搜索")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "page", value = "第几页", defaultValue = "1", example = "1", dataType = "Integer", paramType = "query")
            ,@ApiImplicitParam(name = "limit", value = "每页多少条", defaultValue = "10", example = "10", dataType = "Integer", paramType = "query")
            ,@ApiImplicitParam(name = "sort", value="排序字段名", defaultValue = "create_time", example = "create_time", dataType = "String", paramType = "query")
            ,@ApiImplicitParam(name = "order", value="排序规则(asc:正序, desc:倒序)", defaultValue = "asc", example = "asc", dataType = "String", paramType = "query")
    })
    @GetMapping("/listAlarm")
    public PageResult<CellInventorySpaceVO> listAlarm(
            @RequestParam(defaultValue = "1") Integer page
            ,@RequestParam(defaultValue = "10") Integer limit
            ,@RequestParam(defaultValue = "create_time") String sort
            ,@RequestParam(defaultValue = "asc") String order
            ,String code
            ,String cabCode
            ,String skuCode
            ,String skuCode4Detail
            ,String spaceCode
    ){

        Page<CellInventorySpace> pg = new Page<>(page, limit);
        Map queryParam=new HashMap();
        queryParam.put("sort",StrUtil.toUnderlineCase(sort));
        queryParam.put("order",order);
        queryParam.put("code",code);
        queryParam.put("cabCode",cabCode);
        queryParam.put("skuCode",skuCode);
        queryParam.put("skuCode4Detail",skuCode4Detail);
        queryParam.put("spaceCode",spaceCode);
        //搜索
        IPage<CellInventorySpaceVO> list = cellInventorySpaceService.pageList(pg,queryParam);
        List<CellInventorySpaceVO> alarmProduct = cellInventorySpaceService.getAlarmProduct(list.getRecords());
        list.setRecords(alarmProduct);
        return new PageResult<>(list.getRecords(), list.getTotal());
    }



    @ApiOperation(value = "添加售刀柜产品货道库存", notes = "添加")
    @RequestObjectFieldIgnore({"id", "createTime", "remark"})
    @PostMapping("/add")
    public JsonResult add(@Validated(CellInventorySpaceForm.Add.class) CellInventorySpaceForm cellInventorySpaceForm) {
        if (cellInventorySpaceService.add(cellInventorySpaceForm) > 0) {
            return JsonResult.success("添加成功");
        }
        return JsonResult.fail("添加失败");
    }




    @ApiOperation(value = "修改售刀柜产品货道库存", notes = "修改")
    @PutMapping("/update")
    public JsonResult update(@Validated(CellInventorySpaceForm.Update.class) CellInventorySpaceForm cellInventorySpaceForm) {
        CellInventorySpace cellInventorySpace = cellInventorySpaceService.getById(cellInventorySpaceForm.getId());
        if(cellInventorySpace == null){
        return JsonResult.fail("修改失败！");
        }
        CopyOptions copyOptions = CopyOptions.create()
        .setEditable(CellInventorySpace.class)
        .setIgnoreError(true)
        .setIgnoreNullValue(true);
        BeanUtil.copyProperties(cellInventorySpaceForm, cellInventorySpace, copyOptions);
        if (cellInventorySpaceService.updateById(cellInventorySpace)) {
            return JsonResult.success("修改成功！");
        }
        return JsonResult.fail("修改失败！");
    }



@ApiOperation(value = "删除售刀柜产品货道库存", notes = "删除")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "cellInventorySpaceId", value = "售刀柜产品货道库存id", required = true, dataType = "Integer", paramType = "path")
    })
    @DeleteMapping("/{id}" )
    public JsonResult delete(@PathVariable("id") Long cellInventorySpaceId) {
        if (cellInventorySpaceService.removeById(cellInventorySpaceId)) {
            return JsonResult.success("删除成功");
        }
        return JsonResult.fail("删除失败");
    }

    @ApiOperation(value = "查询所有货道", notes = "搜索")
    @GetMapping("/queryAll")
    public JsonResult queryAll(){
        return JsonResult.success(cellInventorySpaceService.list());
    }

    @ApiOperation(value = "导出按货道库存数据")
    @GetMapping("/export")
    public void export(HttpServletResponse response, String productName){
        List<CellInventorySpaceVO> cellInventorySpaceVOList = new ArrayList<>();
        Map paramsMap = new HashMap();
        paramsMap.put("productName",productName);
        paramsMap.put("sort",StrUtil.toUnderlineCase("create_time"));
        paramsMap.put("order","asc");
        cellInventorySpaceVOList = cellInventorySpaceService.ecxportList(paramsMap);


        ExcelUtils.export(response,"库存列表（按货道）",cellInventorySpaceVOList, CellInventoryProductVO.class);
    }

    @ApiOperation(value = "上货时查询货道库存提示", notes = "查询")
    @GetMapping("/getCellInventorySpaceBySkuCode")
    public JsonResult<String> getCellInventorySpace(String cabCodes,String skuCode){
        StringBuffer result=new StringBuffer();
        String[] cabCodesArray=cabCodes.split(",");
        Map paramMap=new HashMap();
        paramMap.put("cabCodes",cabCodesArray);
        paramMap.put("skuCode4app",skuCode);
        List<CellInventorySpaceVO> cellInventorySpaceVOS=cellInventorySpaceService.list4app(paramMap);
        List<StorageInventorySpaceVO> storageInventorySpaceVOS = storageInventorySpaceService.list4app(paramMap);
        if (cellInventorySpaceVOS.size()==0 && storageInventorySpaceVOS.size() == 0){
            return JsonResult.success("","");
        }else{
            if(cellInventorySpaceVOS.size() > 0){
                cellInventorySpaceVOS.forEach(e->{
                    result.append(""+e.getCabName()+"-"+e.getSpaceCode()+"("+e.getQuantity()+"/"+e.getLaneCapacity()+")、");
                });
            }
            if(storageInventorySpaceVOS.size()>0){
                storageInventorySpaceVOS.forEach(e->{
                    result.append(""+e.getCabName()+"-"+e.getSpaceCode()+"("+e.getQuantity()+"/"+e.getLaneCapacity()+")、");
                });
            }
            return JsonResult.success("","以下货道已有该产品："+result.toString().substring(0,result.toString().length()-1));
        }

    }
}
